package com.zhuiYun.project.api.ordersappraise.mapper;

import com.zhuiYun.project.api.ordersappraise.entity.OrdersAppraiseEntity;
import com.zhuiYun.project.common.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * LC: 2023-04-05 14:40
 */
public interface OrdersAppraiseMapper extends BaseMapper<OrdersAppraiseEntity> {
    /**
    * @Author kdj
    * @Description 根据ordersId获取商品id
    * @Date 2023/4/11 16:11
    * @Return java.lang.Integer
    * @param ordersId
    */
    @Select("SELECT diy_id FROM orders_appraise a , handwork_diy_order b WHERE a.orders_id =b.orders_id and  a.orders_id = #{orderId}")
    Integer getDiyIdByOrdersId(int ordersId);
}
